Chain-sys 1st round

1. Introduce yourself.
2. Rate in SQL and PLSQL.
3. Explain about subquery.
4. Explain right outer join.
5. Explain performance tuning.
6. What are the methods using in performance tuning.
7. Explain views.
8. Datas insert in view, it will affect in master table?
9. Different user inset the data in same table, what will happen.
10. Explain about trigger.
11. You can use commit inside trigger?
12. Explain about pragma autonomous transactions.
13. Explain about anonymous block
14. Different between procedure and function.
15. Able to call procedure inside function?
16. Explain about cursor.
17. Cursor types.
18. Explain refursor.
19. Explain about bulk collect.
20. Explain about exception.
21. Exceptions types.
22. Advantages of bulk collect.